Physics Lessons/Physics Lessons.iso/mac/Future Graph Sample Courseware/system/FULLLIST.TXT

Text File | 1996-06-14 | 34.5 KB | 1,264 lines | [TEXT/ttxt]

GENERAL COMMANDS
Active Screen=
Active Window Calc ()
Active Window Draw ()
Active Window Graph ()
Active Window Spread ()
Animate (Filename, Count, Delay, X1, Y1, X2, Y2)
Button Commands ->
Calc Angular Mode=
Calc Output Base=
Calc Output Format (format, digits)
Calc Output Just=
Calc View Graph Def ()
Calc View Spread Def ()
Calc View User Def ()
Call Filename
Cell Store (Col, Row, Expression)
Clear Calc Window ()
Cls ()
Complex Commands ->
Convert Picture (Filename, OutputFormat, OptionalDriveLetter)
Convolve (Range1, Range2, Dest Cell)
Curve Fit Poly Order=
Curve Fit Type=
DataBase Commands ->
Date Value (String)
Degrees ()
Delay (MilliSeconds)
Delete
Df
Dos Memory Reserve=
Dos Pause Option=
Dos Repeat Command ()
Dos
Ds
Dv
Eat Mem (Bytes)
Echo (String)
Echo And Execute (Command)
Edit File (Filename)
Ev (Expression)
Ev To Col (Expression, Dest)
Ev To Row (Expression, Dest)
Execute (Command)
Exit ()
Extract (FileName, FullExtractModeFlag)
FFT (Range1, Range2, Dest Cell)
FFT Inv (Range1, Range2, Dest Cell)
File Commands ->
FuncData Commands ->
Gradians ()
Graph Commands ->
Halt ()
Help ()
Help Screen (Library, ScreenId)
Input Commands ->
Integral2 ()
Integral3 ()
Let
Mat Add (Range1, Range2, Dest Cell)
Mat Det (Range, Dest Cell)
Mat Inv (Range, Dest Cell)
Mat Mul (Range1, Range2, Dest Cell)
Mat Solve (Range, Dest Cell)
Mat Trans (Range)
Mouse Off ()
Mouse On ()
Mouse Position (X, Y)
Name Range (\Sales\, A1..A7)
New ()
Newton Root (..)
Options Commands ->
Output Number (Number)
Output Text (Text)
Pause ()
Pick String (n, Dest, HowMany, String1, .., StringN)
PieSlice Commands ->
Power Spectrum (Range1, Range2, Dest Cell)
Print Commands ->
Program Exec Delay=
Program Exec Mode=
Programming Commands ->
Quit ()
Radians ()
Range Commands ->
Recorder Dest=
Recorder Mode=
Refresh Screen ()
Resume ()
Run Filename
Sample Interval (PopRange, Dest, NumberOfSamples, Interval)
Sample Random (PopRange, Dest, NumberOfSamples)
Screen Commands ->
Search Execute ()
Search For Replace With (Old, New)
Search For Replace X ()
Search For Text (Text)
Search For Value (X)
Set HArray (Range, Int, Expression)
Set Matrix (Range, Col, Row, Expression)
Set VArray (Range, Int, Expression)
Show Commands ->
Sigma (Xdata)
Sort Block (Range)
Sort Criterion (KeyId, Range, Order)
Sort Execute ()
Sort Reset ()
Sort ResetKey (KeyId)
Sound (frequence, duration)
Spread Commands ->
Sprintf (Cell, Text)
Start Up Pref Load (Filename)
Start Up Pref Save (Filename)
Str Commands ->
Sys Date ()
Sys Time ()
T Test Pop Mean=
Time Value (String)
Vga Palette (Id, Color)
Window Coord (Id, x1, y1, x2, y2)
Window Move (Id, dx, dy)
Window Resize (Id, dx, dy)
Window Zoom ()
Windows Refresh ()
Windows Stack ()
Windows Tile ()

FUNC DATA COMMANDS
Func Data Area Fill (Pattern, Color)
Func Data Area Fill Type=
Func Data Bar Line (LineStyle, Color)
Func Data Bar Picture File Name (String)
Func Data Bar Secondary (Pattern, Color)
Func Data Bar Tertiary (Pattern, Color)
Func Data Bar Type=
Func Data Complex Fill Points=
Func Data Error Bars X (LineStyle, LineColor, LineThickness)
Func Data Error Bars X Length=
Func Data Error Bars X Mode=
Func Data Error Bars X Range (Range)
Func Data Error Bars Y (LineStyle, LineColor, LineThickness)
Func Data Error Bars Y Length=
Func Data Error Bars Y Mode=
Func Data Error Bars Y Range (Range)
Func Data Fill (Pattern, Color)
Func Data Flip to Front ()
Func Data Histogram (Pattern, Color)
Func Data Histogram Type=
Func Data Interior Label Format=
Func Data Join Points (Style, Color, Thickness)
Func Data Join Points Status=
Func Data Legend Entry (String)
Func Data Marker=
Func Data Marker Color=
Func Data Marker Point Size=
Func Data Marker Fill Pattern=
Func Data Next ()
Func Data Pick=
Func Data Pick List (HowMany, Id1, .., IdN)
Func Data Pref Load (Filename)
Func Data Pref Save (Filename)
Func Data Select All ()
Func Data Unselect All ()

BUTTON COMMANDS
Button (X1, Y1, Title)
Button Draw Viewport (Title, Vminx, Vminy, Vmaxx, Vmaxy, x1, y1, x2, y2)
Button Graph (GraphPage, x1, y1, x2, y2)
Button Graph Horz List (HowMany, GraphPage, .., GraphPageN, x1, y1, x2, y2)
Button Graph Vert List (HowMany, GraphPage, .., GraphPageN, x1, y1, x2, y2)
Button Horz List (HowMany, Title1, .., TitleN, x1, y1)
Button Picture (Title, Filename, x1, y1, x2, y2)
Button Picture Horz List (HowMany, Filename1, .., FilenameN, x1, y1, x2, y2)
Button Picture Vert List (HowMany, Filename1, .., FilenameN, x1, y1, x2, y2)
Button Radio (Title, X, Y, HowManyColumns, HowManyStrings, String1, .., StringN, EditFlag)
Button Record Resume ()
Button Record Start ()
Button Record Stop ()
Button Spread List (Range)
Button Spread Radio List (Range, Dest Cell)
Button Spreadsheet (Title, Start, x1, y1, x2, y2, EditFlag)
Button Text (Title, Filename, x1, y1, x2, y2)
Button Vert List (HowMany, Title1, .., TitleN, x1, y1)

COMPLEX COMMANDS
Complex Abs (Real, Imag)
Complex Angle (Real, Imag)
Complex ArcCos (Real, Imag)
Complex ArcSin (Real, Imag)
Complex ArcTan (Real, Imag)
Complex Conj (Real, Imag)
Complex Cos (Real, Imag)
Complex Cosh (Real, Imag)
Complex Divide (Real1, Imag1, Real2, Imag2)
Complex Exp (Real, Imag)
Complex Ln (Real, Imag)
Complex Log (Real, Imag)
Complex Minus (Real1, Imag1, Real2, Imag2)
Complex Power (Real1, Imag1, Real2, Imag2)
Complex Plus (Real1, Imag1, Real2, Imag2)
Complex Sin (Real, Imag)
Complex Sinh (Real, Imag)
Complex Sqrt (Real, Imag)
Complex Tan (Real, Imag)
Complex Times (Real1, Imag1, Real2, Imag2)
Complex Tanh (Real, Imag)

DATABASE COMMANDS
Database Criterion (Range)
Database Delete ()
Database Extract ()
Database Find ()
Database Input (Range)
Database Output (Range)
Database Reset ()
Database Unique ()

FILE COMMANDS
File Attrib (Filename, Attributes)
File Copy (Source, Dest)
File Delete (Filename)
File Exists (Filename)
File Export All Draw Pages (Filename)
File Export All Graphs (Filename)
File Export Current Draw Page (Filename)
File Export Current Graph (Filename)
File Export Fonts As Text=
File Export Spread (Filename, FileType)
File Export Spread Graphic (Filename)
File Import (Filename, FileType)
File Md (Path)
File Move (Source, Dest)
File Open (Filename)
File Rename (OldName, Newname)
File RmDir (Path)
File Save ()
File Save As (Filename)

GRAPH COMMANDS
Graph Auto Marker=
Graph Bar Depth=
Graph Bar X Spacing=
Graph Bar Y Spacing=
Graph Box Cord (x1, y1, x2, y2)
Graph Display Mode=
Graph Frame (Pattern, FillColor, LineThickness, LineStyle, LineColor)
Graph Graph (Xdata, Ydata1, .., YdataN)
Graph Hide All Labeling ()
Graph Legend=
Graph Page Add ()
Graph Page Delete Last ()
Graph Page Name (Name)
Graph Page Next ()
Graph Page Pick=
Graph Page Pick List (HowMany, GraphPage1, .., GraphPageN)
Graph Page Pref Load (Filename)
Graph Page Pref Save (Filename)
Graph Page Previous ()
Graph Parsing=
Graph Pie Shadow (Pattern, Color)
Graph Polar (Xdata, Ydata1, .., YdataN)
Graph Polar Frame (LineStyle, Color, Thickness)
Graph Polar Frame Rings=
Graph Scaling Auto ()
Graph Scaling Manual (Minx, Miny, Maxx, Maxy)
Graph Scaling Trig ()
Graph Scaling Mode=
Graph Select (Xdata, Ydata)
Graph Show Filename (Filename)
Graph Stretch To Fit Picture=
Graph Text (Id, Text)
Graph Text Control (Id, X, Y, FontPrefFilename)
Graph Text Hide All=
Graph Type=
Graph Unselect (Xdata, Ydata)
Graph Update ()
Graph Window (Pattern, FillColor, LineThickness, LineStyle, LineColor)
Graph WYSIWYG=
Graph X Axis Status=
Graph X Label (Format,FontPrefFilename, LogScaleFlag)
Graph X Major Grid (LineStyle, Color, LineThickness)
Graph X Major Tick Marks=
Graph X Minor Grid (LineStyle, Color, LineThickness)
Graph X Minor Tick Marks=
Graph Y Axis Status=
Graph Y Label (Format,FontPrefFilename, LogScaleFlag)
Graph Y Major Grid (LineStyle, Color, LineThickness)
Graph Y Major Tick Marks=
Graph Y Minor Grid (LineStyle, Color, LineThickness)
Graph Y Minor Tick Marks=

INPUT COMMANDS
Input Cursor (x, y)
Input Data Base (Record)
Input Demo Mode=
Input Dimensions (Height, Width)
Input Menu (HowMany, String1, .., StringN)
Input Multi Line Text (Title, Input, Output, EditFlag)
Input Number (Title)
Input Ok Cancel (Title)
Input Scrolling Window (Title, HowMany, String1, .., StringN)
Input Spread Form (Form, Data)
Input Spread Text (Title, Input, Output)
Input Spread Window (Title, InputRange)
Input System Menu (MenuId, DefaultChoice)
Input Text (Title, Dest)
Input Yes No (Title)

OPTIONS COMMANDS
Options Auto Refresh Graph=
Options Auto Refresh Spread=
Options Cursor Blink Speed=
Options Calc Verbose=
Options Calc Scrolling=
Options Item Color (Item, Color)
Options Graph Function Trace=
Options Graph Global Trace=
Options Graph Percent Box=
Options Keyboard Speed (Rate, Delay)
Options Macro Percent Box=
Options Precision=
Options Prompt Before Exit=
Options Recalc Verbose=
Options Run Anywhere=
Options Scrolling Window Show=
Options Spread Authoring=
Options Tool Bar Level=
Options Tool Bar Status=
Options User Level=

PIE SLICE COMMANDS
Pie Slice Explode=
Pie Slice Explosion Radius=
Pie Slice Fill Color=
Pie Slice Fill Pattern=
Pie Slice Legend Entry (Entry)
Pie Slice Line Color=
Pie Slice Line Style=
Pie Slice Next ()
Pie Slice Pick=
Pie Slice Pick List (HowMany, n)
Pie Slice Previous ()
Pie Slice Refresh SS Labels ()
Pie Slice Select All ()
Pie Slice UnSelect All ()

PRINT COMMANDS
Print All Graph Pages ()
Print All Graphs (OnePerPageFlag)
Print AutoColor Translation=
Print Current Graph ()
Print Destination=
Print Draw Current Page ()
Print Draw Used Pages ()
Print Invert Image=
Print Margins (Left, Right, Top, Bottom)
Print Number Of Copies=
Print Orientation=
Printer Type=
Print Resolution=
Print Scale Patterns=
Print Screen Dump ()
Print Serial Port Setup (Baud Rate, Data Bits, Stop Bits, Parity, DTR / CTS)
Print Skip Blank Pages=
Print Spreadsheet ()
Print Spreadsheet Preview ()
Print Spreadsheet Text ()
Print Spread Select Range (Range)
Print Units=

SCREEN COMMANDS
Screen Attr Fill Color=
Screen Attr Fill Pattern=
Screen Attr Line Color=
Screen Attr Line Style=
Screen Attr Line Thickness=
Screen Attr Arrow Type=
Screen Attr Box Type=
Screen Attr Text Bold=
Screen Attr Text Font=
Screen Attr Text Italic=
Screen Attr Text Underline=
Screen Circle (x1, y1, r)
Screen Clear ()
Screen Ellipse (x1, y1, rx, ry)
Screen Line (x1, y1, x2, y2)
Screen Line To (x1, y1)
Screen Move To (x1, y1)
Screen Polygon (X, Y)
Screen Rectangle (x1, y1, x2, y2)
Screen Restore (x, y, Handle)
Screen Rubber Box (x1, y1, x2, y2, MoveFlag)
Screen Save (x1, y1, x2, y2, Handle)
Screen Text Attributes (filename)
Screen Text Line (x1, y1, S)
Screen Write Mode=
Screen WYSIWYG Text Line (x1, y1, Point Size, Text)

SHOW COMMANDS
Show Draw Viewport (Title, Vminx, Vminy, Vmaxx, Vmaxy, x1, y1, x2, y2)
Show Graph (Title, GraphPage, x1, y1, x2, y2)
Show Picture (Title, Filename, x1, y1, x2, y2)
Show Spreadsheet (Title, RangeType R, x1, y1, x2, y2)
Show Text File (Title, Filename, x1, y1, x2, y2)
Show WYSIWYG Text File (Title, Filename, x1, y1, x2, y2)

SPREAD COMMANDS
Spread Address Cell (Col, Row, Str, AbsoulteFlag)
Spread Address Range (Col1, Row1, Col2, Row2, String, AbsoulteFlag)
Spread Attr Arrow Type=
Spread Attr Box Type=
Spread Attr Fill Color=
Spread Attr Fill Pattern=
Spread Attr Line Color=
Spread Attr Line Style=
Spread Attr Line Thickness=
Spread Audit Circular Ref=
Spread Audit Formulas as Text=
Spread Audit Map Mode=
Spread Audit Range Ref=
Spread Cell Format Digits=
Spread Col Width (Col, NumberOfCharacters)
Spread Cursor Column=
Spread Cursor Row=
Spread Edit Copy (Source, Dest)
Spread Edit Copy to Range (Source, Dest)
Spread Edit Erase (Range, Mode)
Spread Edit Fill (Range)
Spread Edit Highlight (Range)
Spread Edit Move (Source, Dest)
Spread Edit Name Range (Name, Range)
Spread Edit Redo ()
Spread Edit Undo ()
Spread Get Dir (Directory, Dest, DateAndTimeFlag, SizeFlag, AttributesFlag, FullPathFlag)
Spread Range Constant=
Spread Show Build Equation=
Spread Show Column Heading=
Spread Show Display Graphics=
Spread Show Horizontal Grid=
Spread Show Input Bar=
Spread Show Lock Column Title=
Spread Show Lock Row Titles=
Spread Show Pref Load (Filename)
Spread Show Pref Save (Filename)
Spread Show Row Heading=
Spread Show Text Boxes=
Spread Show Vertical Grid=
Spread WYSIWYG=

STR COMMANDS
Str Append (StringDest Dest, String Src)
Str Compare (String Str, String Src, Bool IgnoreCaseFlag)
Str Compare N (String Str, String Src, Int Len, Bool IgnoreCaseFlag)
Str Copy (StringDest Dest, String Src)
Str Copy N (StringDest Dest, String Src, Int Len)
Str Find (String Str, CharType Ch)
Str Find Any Char (String Str, String List)
Str Find Reverse (String Str, CharType Ch)
Str Find String (String Src, String Str)
Str Length (String)
Str Reverse (String)
Str Set (String, Ch)
Str Set N (String, Ch, Len)
Str To Lower (String)
Str To Upper (String)

PROGRAMMING COMMANDS
Start Tutorial ()
End Tutorial ()
#
ELSE
FOR
IFF
GOSUB
GOTO
RETURN
WHILE

RANGE ARITHMETIC COMMANDS
Range Add (Range1, Range2, Dest Cell)
Range Divide (Range1, Range2, Dest Cell)
Range Divided By Constant (Range1, Dest Cell)
Range Minus Constant (Range1, Dest Cell)
Range Multiply (Range1, Range2, Dest Cell)
Range Plus Constant (Range1, Dest Cell)
Range Power (Range1, Range2, Dest Cell)
Range Power Constant (Range1, Dest Cell)
Range Subtract (Range1, Range2, Dest Cell)
Range Times Constant (Range1, Dest Cell)

RANGE CALCULUS COMMNADS
Range Derivative (Range1, Range2, Dest Cell)
Range Integral (Range1, Range2, Dest Cell)

RANGE CURVE FITTING COMMANDS
Range Best Fit (Range1, Range2, Dest Cell)
Range Cubic Spline Interp (Range1, Range2, Dest Cell)
Range Curve Fit (Range1, Range2, Dest Cell)
Range LagRange Interpol (Range1, Range2, Dest Cell)
Range Multi Line Fit (Range1, Range2, Dest Cell)
Range Multiple Regression (Range1, Range2, Dest Cell)
Range Polynomial Fit (Range1, Range2, Dest Cell)
Range Smooth Data (Range1, Range2, Dest Cell)

RANGE DATABASE COMMANDS
Range DatabaseCriterion (Range)
Range DatabaseInput (Range)
Range DatabaseOutput (Range)

RANGE DSP COMMANDS
Range Convolve (Range1, Range2, Dest Cell)
Range FFT (Range1, Range2, Dest Cell)
Range FFT Inv (Range1, Range2, Dest Cell)
Range Power Spectrum (Range1, Range2, Dest Cell)
Range Window Blackman (Range1, Range2, Dest Cell)
Range Window Hamming (Range1, Range2, Dest Cell)
Range Window Hanning (Range1, Range2, Dest Cell)
Range Window Parzen (Range1, Range2, Dest Cell)
Range Window Welch (Range1, Range2, Dest Cell)

RANGE ENG & PHYSICS COMMANDS
Range Bessel (Range, Dest Cell)
Range Beta (Range, Dest Cell)
Range ErrFunc (Range, Dest Cell)
Range ErrFuncComp (Range, Dest Cell)
Range Gamma (Range, Dest Cell)
Range Hermite (Range, Dest Cell)
Range IncBeta (Range, Dest Cell)
Range IncGamma (Range, Dest Cell)
Range IncGammaComp (Range, Dest Cell)
Range Jacobi (Range, Dest Cell)
Range Laguerre (Range, Dest Cell)
Range Legend (Range, Dest Cell)
Range LogGamma (Range, Dest Cell)
Range ModBesselI (Range, Dest Cell)
Range ModBesselK (Range, Dest Cell)
Range Tchebyshev (Range, Dest Cell)

RANGE FORMATTING COMMANDS
Range FormatComma (Range)
Range FormatCurrency (Range)
Range FormatDateFive (Range)
Range FormatDateFour (Range)
Range FormatDateOne (Range)
Range FormatDateSix (Range)
Range FormatDateThree (Range)
Range FormatDateTwo (Range)
Range FormatFixed (Range)
Range FormatGeneral (Range)
Range FormatLogical (Range)
Range FormatPercent (Range)
Range FormatPlusMinus (Range)
Range FormatScientific (Range)
Range FormatSigFigs (Range)
Range FormatText (Range)
Range FormatTimeFour (Range)
Range FormatTimeOne (Range)
Range FormatTimeThree (Range)
Range FormatTimeTwo (Range)
Range JustAuto (Range)
Range JustCenter (Range)
Range JustLeft (Range)
Range JustRight (Range)
Range SelectPrintRange (Range)

RANGE LOGICAL COMMANDS
Range AND (Range, Range, Dest Cell)
Range BON (Range, Range, Dest Cell)
Range LAND (Range, Range, Dest Cell)
Range LBON (Range, Range, Dest Cell)
Range LNAND (Range, Range, Dest Cell)
Range LNOR (Range, Range, Dest Cell)
Range LNOT (Range, Dest Cell)
Range LOR (Range, Range, Dest Cell)
Range LXOR (Range, Range, Dest Cell)
Range NAND (Range, Range, Dest Cell)
Range NOR (Range, Range, Dest Cell)
Range NOT (Range, Dest Cell)
Range OR (Range, Range, Dest Cell)
Range XOR (Range, Range, Dest Cell)

RANGE MATRIX COMMANDS
Range Matrix Determ (Range, Dest Cell)
Range Matrix Inv (Range, Dest Cell)
Range Matrix Multiply (Range1, Range2, Dest Cell)
Range Matrix Solve (Range, Dest Cell)
Range Matrix Transpose (Range)

RANGE RELATIONAL COMMANDS
Range Equal (Range1, Range2, Dest Cell)
Range Greater Than (Range1, Range2, Dest Cell)
Range Greater Than EQ (Range1, Range2, Dest Cell)
Range Less Than (Range1, Range2, Dest Cell)
Range Less Than EQ (Range1, Range2, Dest Cell)
Range Not Equal (Range1, Range2, Dest Cell)

RANGE SPECIAL MATH COMMANDS
Range Abs (Range1, Dest Cell)
Range Exp (Range1, Dest Cell)
Range Factorial (Range1, Dest Cell)
Range Frac (Range1, Dest Cell)
Range Int (Range1, Dest Cell)
Range Inv (Range1, Dest Cell)
Range Ln (Range1, Dest Cell)
Range Log (Range1, Dest Cell)
Range Pow 10 (Range1, Dest Cell)
Range Sqrt (Range1, Dest Cell)

RANGE SS GRAPHICS COMMANDS
Range Insert Arrow (Range)
Range Insert Box (Range)
Range Insert Graph (Range)
Range Insert Picture (Range)
Range Insert Table (Range)
Range Insert Text Box (Range)
Range Insert Viewport (Range)

RANGE STATISTICS COMMANDS
Range Cum Dist (Scores Range, Bin Range Dest Cell)
Range Diff Sq (X1 Range, X2 Range, Dest Cell)
Range Frequency Dist (Range1, Dest Cell)
Range Min Max Range (Range1, Dest Cell)
Range Normalize (Range1, Dest Cell)
Range NormProbStats (Range1, Range2, Dest Cell)
Range Percent Diff (X1 Range, X2 Range, Dest Cell)
Range Percentile Rank (Range1, Dest Cell)
Range R to Z (Range, Dest Cell)
Range Relative Dist (Scores Range, Bin Range Dest Cell)
Range Running Sum (Range1, Dest Cell)
Range Shuffle Range (Range1)
Range Stat Rep (Range, Dest Cell)
Range Zscore (Range, Dest Cell)

RANGE TRANSFORMATIONS COMMANDS
Range Column To Row (Range, Dest Cell)
Range Copy as Values (Range, Dest Cell)
Range Delete Column (Range, Dest Cell)
Range Delete Row (Range, Dest Cell)
Range Insert Column (Range, Dest Cell)
Range Insert Row (Range, Dest Cell)
Range Move Column (Range, Dest Cell)
Range Move Row (Range, Dest Cell)
Range Parse (Range, Dest Cell)
Range Parse Flat (Range, Dest Cell)
Range Reverse Column (Range, Dest Cell)
Range Reverse Row (Range, Dest Cell)
Range Row To Column (Range, Dest Cell)

RANGE TRIGONOMETRIC COMMANDS
Range ArcCos (Range, Dest Cell)
Range ArcCosH (Range, Dest Cell)
Range ArcCot (Range, Dest Cell)
Range ArcCotH (Range, Dest Cell)
Range ArcCsc (Range, Dest Cell)
Range ArcCscH (Range, Dest Cell)
Range ArcSec (Range, Dest Cell)
Range ArcSecH (Range, Dest Cell)
Range ArcSin (Range, Dest Cell)
Range ArcSinH (Range, Dest Cell)
Range ArcTan (Range, Dest Cell)
Range ArcTanH (Range, Dest Cell)
Range Cos (Range, Dest Cell)
Range CosH (Range, Dest Cell)
Range Cot (Range, Dest Cell)
Range CotH (Range, Dest Cell)
Range Csc (Range, Dest Cell)
Range CscH (Range, Dest Cell)
Range Sec (Range, Dest Cell)
Range SecH (Range, Dest Cell)
Range Sin (Range, Dest Cell)
Range SinH (Range, Dest Cell)
Range Tan (Range, Dest Cell)
Range TanH (Range, Dest Cell)

RANGE VECTOR COMMANDS
Range CartAngle (Range, Dest Cell)
Range CartDist (Range, Dest Cell)
Range CartMag (Range, Dest Cell)
Range CartX (Range, Dest Cell)
Range CartY (Range, Dest Cell)
Range Dot (Range, Dest Cell)
Range DotAngle (Range, Dest Cell)
Range PolarAngle (Range, Dest Cell)
Range PolarDist (Range, Dest Cell)
Range PolarMag (Range, Dest Cell)
Range PolarX (Range, Dest Cell)
Range PolarY (Range, Dest Cell)
Range TdCartDist (Range, Dest Cell)
Range TdCartheta (Range, Dest Cell)
Range TdCartMag (Range, Dest Cell)
Range TdCartPhi (Range, Dest Cell)
Range TdCrossX (Range, Dest Cell)
Range TdCrossY (Range, Dest Cell)
Range TdCrossZ (Range, Dest Cell)
Range TdDotAngle (Range, Dest Cell)
Range TdSpherDist (Range, Dest Cell)
Range TdSpherX (Range, Dest Cell)
Range TdSpherY (Range, Dest Cell)
Range TdSpherZ (Range, Dest Cell)

ARITHMETIC FUNCTIONS
(A) + (B)
(A) - (B)
(A) * (B)
(A) / (B)
(A) ^ (B)
(A)!
(A) % (B)

STATISTIC FUNCTION
Average Deviation (Range1, Range2, Range3, ..., RangeN)
Avg Error (Yk Data Range, f(Xk) Data Range)
AVG (Range1, Range2, Range3, ..., RangeN)
Coeff Deter (X Data Range, Y Data Range)
Corr Coeff (X Data Range, Y Data Range)
Geometric Mean (Range1, Range2, Range3, ..., RangeN)
Harmonic Mean (Range1, Range2, Range3, ..., RangeN)
Kurtosis (Range1, Range2, Range3, ..., RangeN)
Max (Range1, Range2, Range3, ..., RangeN)
Max Error (Yk Data Range, f(Xk) Data Range)
Mean (Range1, Range2, Range3, ..., RangeN)
Median (Range1, Range2, Range3, ..., RangeN)
Min (Range1, Range2, Range3, ..., RangeN)
Mode (Range1, Range2, Range3, ..., RangeN)
Percent Diff (X1 Range, X2 Range)
Pop StdDev (Range1, Range2, Range3, ..., RangeN)
Pop Variance (Range1, Range2, Range3, ..., RangeN)
Product (Range1, Range2, Range3, ..., RangeN)
R to Z (R)
Rms Error (Yk Data Range, f(Xk) Data Range)
Root Mean Square (Range1, Range2, Range3, ..., RangeN)
Skewness (Range1, Range2, Range3, ..., RangeN)
Standard Deviation (Range1, Range2, Range3, ..., RangeN)
StatRep.Maximum()
StatRep.Mean()
StatRep.Minimum()
StatRep.PopStDev()
StatRep.PopVar()
StatRep.Range()
StatRep.Sample Size()
StatRep.SampleStDev()
StatRep.SampleVar()
StatRep.Sum()
STD (Range1, Range2, Range3, ..., RangeN)
Std Error (Range A, Range B)
STDS (Range1, Range2, Range3, ..., RangeN)
Sum of Squares (Range1, Range2, Range3, ..., RangeN)
Sum of Sq Devs (X1 Range, X2 Range)
Sum (Range1, Range2, Range3, ..., RangeN)
ValueRange (Range1, Range2, Range3, ..., RangeN)
Var (Range1, Range2, Range3, ..., RangeN)
Variance (Range1, Range2, Range3, ..., RangeN)
Vars (Range1, Range2, Range3, ..., RangeN)
Weighted Mean (Range1, Range2)

TRIGONOMETRIC FUNCTIONS
ACos (X)
ArcCos (X)
Arccosh (X)
ArcCot (X)
Arccoth (X)
ArcCsc (X)
Arccsch (X)
ArcSec (X)
Arcsech (X)
ArcSin (X)
Arcsinh (X)
ArcTan (X)
Arctanh (X)
ASin (X)
ATan (X)
ATanII (Delta X, Delta Y)
Cos (theta)
Cosh (X)
Cot (theta)
Coth (X)
Csc (theta)
Csch (X)
Sec (theta)
Sech (X)
Sin (theta)
Sinh (X)
Tan (theta)
Tanh (X)

SPECIAL FUNCTIONS
Abs (X)
ArithProg (a, d, n)
Ceil (X)
Choose (N, X1, ..., Xn)
Combinations (n, r)
Count (Range1, Range2, Range3, ..., RangeN)
Exp (X)
FALSE
Floor (X)
Frac (X)
GeometProg (a, r, n)
Int (X)
Inv (X)
Is Even (X)
Is Multiple (X, Y)
Is Odd (X)
LCM (X1, X2, ..., Xn)
Ln (X)
Log (X)
LogN (X, N)
Mod (X, Y)
Nroot (X, N)
NSamples (alpha, sigma, epsilon)
Permutations (n, r)
Pi
Rnd (Min, Max)
Round (X, N)
Sign (X)
Sqrt (X)
Step (X, A)

2-DIMENSIONAL (2D) VECTOR FUNCTIONS

CartAngle (X, Y)
CartDist (X1, Y1, X2, Y2)
CartMag (X1, Y1)
CartX (Y, Theta)
CartY (Y, Theta)
Dot (X1, Y1, X2, Y2)
DotAngle (X1, Y1, X2, Y2)
PolarAngle (r, X)
PolarDist (r1, Theta1, r2, Theta2)
PolarMag (x, Theta)
PolarX (r, Theta)
PolarY (r, Theta)

3 DIMENSIONAL (3D) VECTOR FUNCTIONS

TdCartDist (X1, Y1, Z1, X2, Y2, Z2)
TdCartMag (X, Y, Z)
TdCartPhi (X, Y, Z)
TdCartTheta (X, Y, Z)
TdCrossX (X1, Y1, Z1, X2, Y2, Z2)
TdCrossY (X1, Y1, Z1, X2, Y2, Z2)
TdCrossZ (X1, Y1, Z1, X2, Y2, Z2)
TdDotAngle (X1, Y1, Z1, X2, Y2, Z2)
TdSpherDist (x, y, z)
TdSpherX (r, Theta, phi)
TdSpherY (r, Theta, phi)
TdSpherZ (r, Theta, phi)

CALCULATOR FUNCTIONS
Data Integral (X Range, Y Range)
Derivative (Function(), Variable, X, Order N)
Function Max (Function(), Variable, Lower limit, Upper limit, Step size)
Function Min (Function(), Variable, Lower limit, Upper limit, Step size)
Function Product (Function(), Variable, Lower limit, Upper limit, Step size)
Function Stat Report (Function(), Variable, Lower limit, Upper limit, Step size)
Function X at Max (Function(), Variable, Lower limit, Upper limit, Step size)
Function X at Min (Function(), Variable, Lower limit, Upper limit, Step size)
Integral (Function(), Variable, Lower Limit, Upper Limit)
Sigma (Function(), Variable, Lower limit, Upper limit, Step size)
SigmaN (Function(), X, X Value, N Lower limit, N Upper limit, N Step size)

ENGINEERING FUNCTIONS
Bessel (n,x)
Beta (x,y)
ErrFunc (X)
ErrFuncComp (X)
Gamma (X)
Hermite (n,x)
IncBeta (a,b,x)
IncGamma (a, x)
IncGammaComp (a, x)
Jacobi (n,a,b,x)
LaGuerre (n,a,x)
Legendre (n,x)
LogGamma (X)
Mod Bessel K (n,x)
Mod Bessel I (n,x)
Parallel Inductance (X1, X2, ..., Xn)
Parallel Resistance (X1, X2, ..., Xn)
Parallel Capacitance (X1, X2, ..., Xn)
Series Resistance (X1, X2, ..., Xn)
Series Inductance (X1, X2, ..., Xn)
Series Capacitance (X1, X2, ..., Xn)
Tchebyshev (n,x)

MATRIX FUNCTIONS
MatAdd (Range1, Range2, Dest Cell)
MatMul (Range1, Range2, Dest Cell)
MatInv (Range, Dest Cell)
MatDet (Range, Dest Cell)
MatTrans (Range)
MatSolve (Range, Dest Cell)

CURVE FIT_FUNCTIONS
CurveFit.A ()
CurveFit.AvgError ()
CurveFit.B ()
CurveFit.ChiSquare ()
CurveFit.MaxError ()
CurveFit.R ()
CurveFit.RMSError ()
CurveFit.RSq ()
CurveFit.Terms ()

DSP FUNCTIONS
FFT (Range1, Range2, Dest Cell)
FFT Inv (Range1, Range2, Dest Cell)
Power Spectrum (Range1, Range2, Dest Cell)
Convolve (Range1, Range2, Dest Cell)
Range Window Blackman (Range1, Range2, Dest Cell)
Range Window Hamming (Range1, Range2, Dest Cell)
Range Window Hanning (Range1, Range2, Dest Cell)
Range Window Parzen (Range1, Range2, Dest Cell)
Range Window Welch (Range1, Range2, Dest Cell)

BUSSINESS FUNCTIONS
AMORTIZATION

Amort Balance (Paid, Principle, Rate, Periods)
Amort Per Pmt (Principle, Rate, Periods)
Amort Pmts (Monthly Payment, Principle, Rate)
Amort Total (Principle, Rate, Periods)

ANNUITIES

AnDueFV (Rate, Periods Per Year, Years, Period Payment)
AnDueNoPmts (PV, Period Payment, Rate, Periods Per Year)
AnDuePerToFV (FV, Payment, Rate, Periods Per Year)
AnDuePmtFV (FV, Rate, Periods Per Year, Years)
AnDuePmtPV (PV, Rate, Periods Per Year, Years)
AnDuePV (Rate, Periods Per Year, Time in Years, Payment)
AnDueRate (PV, Period Payment, Periods Per Year, Years)
AnDueRateFV (FV, Period Payment, Periods Per Year, Years)

BONDS
BondDurCoup (Par Value, Coupon Rate, Yield To Maturity, Maturity In Years, Payments Per Year)
BondPriceOnAnn (Par Value, Coupon Rate, Maturity Years, Yield To Maturity, Payments Per Year)
TBillPrice (Rate, Days Till Maturity)
TBillRate (% Of Par, Days Till Maturity)
YieldToMatRate (Par Value, Bond Price, Coupon Rate, Maturity Years, Payments Per Year)

CASH FLOW
DiscPayBackPrd (Discounted Period Rate, Cash Flow Range)
PayBackPrd (Cash Flow Range)
ProfitIndex (Period Rate, Cash Flow Range)

COMPOUNDED INTEREST
AnnEffRate (PV, FV, Years)
AnnRateXComp (PV, FV, Years, Periods Per Year)
InvestReq (FV, Rate, Years, Periods Per Year)
PrdsToGrowMoney (PV, FV, Rate, Periods Per Year)
YrsToGrowMoney (PV, FV, Rate, Periods Per Year)

CONVERSIONS
DiscToSimple (Discount Rate, Years)
EffRateWithComp (Rate, Periods Per Year)
NumPeriods (Years, Periods Per Year)
RatePerPeriod (Rate, Periods Per Year)
SimpleToDisc (Rate, Years)
StdrtWithComp (Effective Rate, Periods Per Year)

DISCOUNT INTEREST
DiscEffLoan (Face Value, Years, Discounted Rate)
DiscInt (Face Value, Years, Discounted Rate)
DiscRate (Face Value, Discounted Amount, Years)
DiscTime (Face Value, Discounted Amount, Rate)

SIMPLE INTEREST
SimInt (Principle, Years, Rate)
SimIntAccum (Principle, Years, Rate)
SimIntPrin (Accumulated Amount, Rate, Years)
SimIntRate (Principle, Years, Accumulated Amount)
SimIntTime (Principle, Accumulated Amount, Rate)

ADDITIONAL FUNCTIONS
CTerm (Period Rate, FV, PV)
DDB (Cost, Salvage Value, Life, Period)
FV (Period Payment, Period Rate, Periods)
IRR (Guess, Cash Flow Range)
NPV (Period Rate, Cash Flow Range)
Pmt (Principal, Period Rate, Periods)
PV (Period Payment, Period Rate, Periods)
RATE (PV, FV, Periods)
SLN (Cost, Salvage, Life)
SYD (Cost, Salvage Value, Life, Period)
TERM (Payment, Rate, FV)

LOGICAL FUNCTIONS
(A) AND (B)
(A) LBON (B)
(A) NAND (B)
(A) NOR (B)
NOT (A)
(A) OR (B)
(A) XOR (B)

RELATIONAL FUNCTIONS
(A) < (B)
(A) == (B)
(A) > (B)
(A) <= (B)
(A) >= (B)
(A) <> (B)

ANGULAR CONVERSION FUNCTIONS
DegGrad (Degrees)
DegRad (Degrees)
GradDeg (Gradians)
GradRad (Gradians)
RadDeg (Radians)
RadGrad (Radians)

ARRAY FUNCTIONS
Cell (Column, Row)
Cell (Column, Row) = Expression
CellStore (Column, Row) = Expression
HArray (Range, N)
HArray (Range, N) = Expression
HLookUp (X, Range, Row)
Index (Range, Col, Row)
Matrix (Range, Col Num, Row Num) = Expression
Matrix (Range, Col Num, Row Num)
VArray (Range, N)
VArray (Range, N) = Expression
VLookUp (X, Range, Col)

BITWISE FUNCTIONS
(A) BAND (B)
Left Rotate (A, N)
Left Shift (A, N)
(A) BNAND (B)
(A) BNOR (B)
BNOT (A)
(A) BOR (B)
Right Shift (A, N)
Right Rotate (A, N)
(A) BXOR (B)

DATABASE FUNCTIONS
DAvg (Input Range, Field Number, Criteria Range)
DCount (Input Range, Field Number, Criteria Range)
DMax (Input Range, Field Number, Criteria Range)
DMin (Input Range, Field Number, Criteria Range)
DProduct (Input Range, Field Number, Criteria Range)
DStd (Input Range, Field Number, Criteria Range)
DStdS (Input Range, Field Number, Criteria Range)
DSum (Input Range, Field Number, Criteria Range)
DVar (Input Range, Field Number, Criteria Range)
DVarS (Input Range, Field Number, Criteria Range)

DATE AND TIME FUNCTIONS
Date (Year, Month, Day)
Date Value (Date String)
Day (Date Value)
Hour (Time Value)
Minute (Time Value)
Month (Date Value)
Now ()
Second (Time Value)
Time (Hours, Minutes, Seconds)
Time Value (Time String)
Year (Date Value)

LIST FUNCTIONS
List Average Deviation (X1, X2, .., Xn)
List Geometric Mean (X1, X2, .., Xn)
List Harmonic Mean (X1, X2, .., Xn)
List Kurtosis (X1, X2, .., Xn)
List Max (X1, X2, .., Xn)
List Mean (X1, X2, .., Xn)
List Median (X1, X2, .., Xn)
List Min (X1, X2, .., Xn)
List Mode (X1, X2, .., Xn)
List Pick (n, X1, X2, .., Xn)
List Product (X1, X2, .., Xn)
List Rand (X1, X2, .., Xn)
List Skew (X1, X2, .., Xn)
List Std (X1, X2, .., Xn)
List StdS (X1, X2, .., Xn)
List Sum (X1, X2, .., Xn)
List Var (X1, X2, .., Xn)
List VarS (X1, X2, .., Xn)

MISC FUNCTIONS
Button Maxx (Button Id)
Button Maxy (Button Id)
Button Minx (Button Id)
Button Miny (Button Id)
Get Ch ()
Get Input ()
Highlight Col Start ()
Highlight Col Stop ()
Highlight Row Start ()
Highlight Row Stop ()
Horz Gauge (Start Value, Min Value, Max Value, X, Y, Length, Edit Flag)
Input Event ()
Input First Key ()
Input Functions
Input Second Key ()
Input Special Key Status ()
Mouse Button X ()
Mouse Button Y ()
Mouse X ()
Mouse X Percent ()
Mouse Y ()
Mouse Y Percent ()
Rubber Box Max X ()
Rubber Box Max Y ()
Rubber Box Min X ()
Rubber Box Min Y ()
Vert Gauge (Start Value, Min Value, Max Value, X, Y, Length, Edit Flag)
Which Button Pressed ()

PROBABILITY FUNCTIONS
Inv Prob Chi (alpha, n)
Inv Prob F (alpha, n1, n2)
Inv Prob Normal (alpha)
Inv Prob T (alpha, n)
Prob Beta (x, alpha, beta)
Prob Boltzman (x, alpha)
Prob BoseEinstein (x, alpha, beta)
Prob ChiSquare (x, n)
Prob Delta (x, u, mu)
Prob F (f, n1, n2)
Prob FermiDirac (x, alpha, beta)
Prob Gamma (x, alpha, mu)
Prob Gauss (x, alpha)
Prob Laplace (x, alpha, mu)
Prob Log Normal (x, alpha, mu)
Prob Lorentz (x, alpha, mu)
Prob Maxwell (x, alpha)
Prob Normal (x, sigma, mu)
Prob Rayleigh (x, alpha)
Prob SechSq (x, alpha, mu)
Prob T (t, n)
Prob Uniform (X, X0, X1)
Prob Weibull (x, u, alpha)
Rand Beta (n1, n2, X1, X2)
Rand Exp (Mean, X1, X2)
Rand F (n1, n2, X1, X2)
Rand Geometric (Probability, X1, X2)
Rand Logistic (a, k)
Rand Lorentz (X1, X2)
Rand Normal (Mean, sigma, X1, X2)
Rand Poisson (Mean, X1, X2)
Rand T (n, X1, X2)
Rand Uniform (X1, X2)
Random seed ()

DISTRIBUTION FUNCTIONS
Dist Beta (x, alpha, beta)
Dist Binomial (x, n, p)
Dist Boltzman (x, alpha)
Dist BoseEinstein (x, alpha, beta)
Dist ChiSquare (x, n)
Dist Delta (x, delta, mu)
Dist Exp (x, theta)
Dist F (X, n1, n2)
Dist FermiDirac (x, alpha, beta)
Dist Gamma (x, alpha, mu)
Dist Gauss (x, alpha)
Dist Geometric (x, p)
Dist HyperGeo (x, n, N1, N2)
Dist Laplace (x, alpha, mu)
Dist Log Normal (x, alpha, mu)
Dist Logistic (x, a, k)
Dist Lorentz (x, alpha, mu)
Dist Maxwell (x, alpha)
Dist NegBinomial (x, n, p)
Dist Normal (x, sigma, mu)
Dist Poisson (x, lamda)
Dist Rayleigh (x, alpha)
Dist SechSq (x, alpha, mu)
Dist T (x, n)
Dist Uniform (x, x0, x1)
Dist Weibull (x, sigma, u)

ROOT FINDING FUNCTIONS
Root Bisection (Function(), Variable, Lower limit, Upper limit)
Root Brent (Function(), Variable, Lower limit, Upper limit)
Root Cubic (a, b, c, d)
Root Error ()
Root Imag (N)
Root Interpolated (Function(), Variable, Lower limit, Upper limit, Step size)
Root Interpolated N (Function(), Variable, Lower limit, Upper limit, Step size, Which Root)
Root Iterative (Function(), Variable, Guess)
Root Linear (Function(), Variable, Lower limit, Upper limit, Step size)
Root Linear N (Function(), Variable, Lower limit, Upper limit, Step size, Which root)
Root Quadratic (a, b, c)
Root Quartic (a, b, c, d, e)
Root Real (N)
Root Secant (Function(), Variable, Lower limit, Upper limit)
Root X ()
Root Y ()

SPREADSHEET FUNCTIONS
Cols (Range)
How Many Blank Cells (Range)
How Many Number Cells (Range)
How Many Text Cells (Range)
How Many Used Cells (Range)
Is Equation (Column, Row)
Is Number (Column, Row)
Is Referenced Equation (Column, Row)
Is Text (Column, Row)
Rows (Range)

STAT TEST FUNCTIONS
Anova (Data Range, Dest Cell)
Anova.DfB ()
Anova.DfT ()
Anova.DfW ()
Anova.FCritA ()
Anova.FCritB ()
Anova.FCritC ()
Anova.Fobt ()
Anova.Ssb ()
Anova.Ssw ()
Anova.VarB ()
Anova.VarW ()
Chi Square (Yk Data Range, f(Xk) Data Range)
Chi.CritA ()
Chi.CritB ()
Chi.CritC ()
Chi.Df ()
Chi.Obt ()
ConTable (Range)
F Test (Range A, Range B)
t Test Related Measures (Range One, Range Two)
t Test (PopMean, Range1, Range2, Range3, .., RangeN)
t Test Ind Meas (Range One, Range Two)
t.CritA ()
t.CritB ()
t.CritC ()
t.df ()
t.Obt ()
t.PopMean ()
t.Sample Mean ()
t.Sample Size ()
t.Sum ()
t.SumofSqs ()
t.SumSq ()
tIndep.ADf ()
tIndep.AMean ()
tIndep.ASumofSqs ()
tIndep.ASumSq ()
tIndep.BDf ()
tIndep.BMean ()
tIndep.BSumofSqs ()
tIndep.BSumSq ()
tIndep.CritA ()
tIndep.CritB ()
tIndep.CritC ()
tIndep.Obt ()
tRelMeas.AMean ()
tRelMeas.BMean ()
tRelMeas.CritA ()
tRelMeas.CritB ()
tRelMeas.CritC ()
tRelMeas.Obt ()
tRelMeas.SampleSize ()
tRelMeas.SumDiffSq ()
tRelMeas.SumofDiffsSq ()